CREATE TABLE [dbo].[discpln]
(
[iK_disc] [int] NOT NULL IDENTITY(1, 1),
[cName_disc] [varchar] (100) COLLATE Cyrillic_General_CI_AS NOT NULL,
[cShortName] [varchar] (40) COLLATE Cyrillic_General_CI_AS NULL,
[lPract] [bit] NOT NULL CONSTRAINT [DF_discpln_lPract] DEFAULT ((0)),
[ik_type_disc] [tinyint] NULL,
[DiplDiscName] [varchar] (150) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[discpln] ADD CONSTRAINT [PK_discpln] PRIMARY KEY CLUSTERED  ([iK_disc]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[discpln] ADD CONSTRAINT [IX_discpln] UNIQUE NONCLUSTERED  ([cName_disc]) ON [PRIMARY]
GO
